| syStudent |
| Logical Entity Name | syStudent |
| Default Table Name | syStudent |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| syStudent Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SSN | varchar(30) | YES | ||
| AmTitleID | int | NO | ||
| LastName | varchar(128) | YES | ||
| FirstName | varchar(128) | YES | ||
| NickName | nvarchar(50) | NO | ||
| MaidenName | nvarchar(50) | NO | ||
| Addr1 | varchar(255) | NO | ||
| Addr2 | char(1) | YES | ||
| City | varchar(25) | NO | ||
| State | char(2) | NO | ||
| Zip | char(10) | NO | ||
| BadAddr | bit | NO | ||
| SyCountryID | int | YES | ||
| SyCountyID | int | NO | ||
| Phone | char(16) | NO | ||
| WorkPhone | char(16) | NO | ||
| Workext | varchar(10) | NO | ||
| BadPhone | bit | NO | ||
| LeadDate | datetime | YES | ||
| AmLeadTypeID | int | NO | ||
| AmSexID | int | NO | ||
| AmRaceID | int | NO | ||
| AmNationalityID | int | NO | ||
| AmMaritalID | int | NO | ||
| DrivLicState | char(2) | NO | ||
| DrivLic | char(20) | NO | ||
| DOB | datetime | YES | ||
| AlienNo | char(9) | YES | ||
| AmAgencyID | int | NO | ||
| AmCitizenID | int | NO | ||
| varchar(128) | NO | |||
| SySchoolStatusID | int | NO | ||
| AmRepID | int | NO | ||
AmLeadSrcID |
int | NO | ||
| SyCampusID | int | NO | ||
| AdProgramGroupID | int | NO | ||
| AdProgramID | int | NO | ||
| AdShiftID | int | NO | ||
| StartDate | datetime | YES | ||
| AmPrevEducID | int | NO | ||
| AmHighSchoolID | int | NO | ||
| AmCollegeID | int | YES | ||
| HsGradDate | datetime | YES | ||
| ARBalance | money | NO | ||
| NextTranNum | smallint | NO | ||
| ArAcctStat | char(2) | NO | ||
| StmtLastDate | datetime | YES | ||
| StmtBeginDate | datetime | YES | ||
| StmtCloseDate | datetime | YES | ||
| StmtComment | varchar(200) | NO | ||
| DefaultAddressCode | char(1) | YES | ||
| DefaultAddressID | int | YES | ||
| PlEmployerID | int | NO | ||
| plEmpStatusID | int | NO | ||
| StuNum | varchar(30) | YES | ||
| PIN | numeric(4, 0) | YES | ||
| Comment | text | NO | ||
| AmExtraCurrID | int | YES | ||
| Active | bit | NO | ||
| DataBlockIndicator | bit | NO | ||
| ModFlag | char(1) | NO | ||
| Userid | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
SyStudentId |
int | NO | ||
| Disabled | char(1) | NO | ||
| Vet | char(1) | NO | ||
| OriginalAmRepID | int | YES | ||
| CumGPA | numeric(11, 6) | YES | ||
| CumGPAPoints | money | YES | ||
| CurrentLDA | datetime | YES | ||
| GPACredits | money | YES | ||
| OriginalStartDate | datetime | YES | ||
| OriginalExpStartDate | datetime | YES | ||
| OtherPhone | char(16) | YES | ||
| OtherEmail | varchar(128) | YES | ||
| LastActivityDate | datetime | YES | ||
| LastInterestDate | datetime | YES | ||
DefaultMasterAddressID |
int | YES | ||
| Suffix | char(3) | YES | ||
| MiddleName | varchar(100) | YES | ||
| NIStudent | bit | NO | ||
| StudentIdentifier | varchar(200) | YES | ||
| PrevEducGPA | numeric(11, 6) | YES | ||
| HSGraduated | bit | NO | ||
| HSGraduationSession | varchar(10) | YES | ||
| HSDateEnrolled | datetime | YES | ||
| HSLastDateAttended | datetime | YES | ||
| HSStudRank | int | YES | ||
| HSSchoolSize | int | YES | ||
| HSTranscriptType | tinyint | YES | ||
| HSStudLevel | tinyint | YES | ||
| HSGradYear | varchar(4) | YES | ||
| LastName_FirstFour | varchar(4) | YES | ||
| Zip_FirstThree | varchar(3) | YES | ||
| DBIModifiedDate | datetime | YES | ||
| BestTimeToContact | varchar(10) | YES | ||
| RawLastName | varchar(25) | YES | ||
| RawFirstName | varchar(25) | YES | ||
| RawPhone | varchar(16) | YES | ||
| ACGEligReasonCode | char(2) | YES | ||
FARigorousHighSchoolProgramCodeID |
int | YES | ||
CMSMSServiceProviderID |
int | YES | ||
| SubscribeToSMS | bit | NO | ||
| MobileNumber | varchar(16) | YES | ||
| SourceSystem | char(1) | NO | ||
| IsHispanic | char(1) | YES | ||
| CrmSuppressFlag | bit | NO | ||
| DDVeteran | bit | NO | ||
| HSAcademicGPA | numeric(11, 6) | YES | ||
AmSuffixID |
int | YES | ||
| AthleticID | varchar(20) | YES | ||
| faGradPlusCounselingDate | datetime | YES | ||
| InDistrict | bit | NO | ||
| DefaultStipendsToEFT | bit | NO | ||
| MI | AS (isnull(left([MiddleName],(1)),' ')) | |||
SyPersonId |
int | YES | ||
| PreferredContactType | nvarchar(20) | YES | ||
| PreferredName | nvarchar(50) | YES | ||
| ExternalStudentIdentifier | nvarchar(250) | YES | ||
| SSNLastFourDigits | AS (right(rtrim([ssn]),(4))) | |||
| IsClearingHouseDBI | bit | NO | ||
| FullName | AS ((ltrim(rtrim([LastName]))+', ')+ltrim(rtrim(isnull([FirstName],'')))) |
| syStudent Primary and Unique Keys |
| Key Name | Key Type | Keys |
| syStudent_SyStudentID_U_C_IDX | PrimaryKey | SyStudentId |
| Nk_SyStudent_LastName_NickName_SyStudentID_U_N_IDX | Index | LastName, NickName, SyStudentId |
| SyStudent_MaidenName_NickName_SyStudentID_U_N_IDX | Index | MaidenName, NickName, SyStudentId |
| SyStudent_WorkPhone_SyCampusID_SyStudentID_U_N_IDX | Index | WorkPhone, SyCampusID, SyStudentId |
| SyStudent_Phone_SyCampusID_SyStudentID_U_N_IDX | Index | Phone, SyCampusID, SyStudentId |
| Nk_SyStudent_MaidenName_NickName_SyStudentID_U_N_IDX | Index | MaidenName, NickName, SyStudentId |
| syStudent Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| amLeadSrc | Non-Identifying | One To Zero or More | FK_syStudent_AmLeadSrcID_AmLeadSrc_AmLeadSrcID | AmLeadSrcID | NO | YES | ||
| CMSMSServiceProvider | Non-Identifying | Zero or One to Zero or More | FK_SyStudent_CMSMSServiceProviderID_CMSMSServiceProvider_CMSMSServiceProviderID | CMSMSServiceProviderID | NO | YES | ||
| SyAddress | Non-Identifying | Zero or One to Zero or More | FK_syStudent_DefaultMasterAddressID_SyAddress_SyAddressID | DefaultMasterAddressID | NO | YES | ||
| FARigorousHighSchoolProgramCode | Non-Identifying | Zero or One to Zero or More | FK_SyStudent_FARigorousHighSchoolProgramCodeID_FARigorousHighSchoolProgramCode_FARigorousHighSchoolProgramCodeID | FARigorousHighSchoolProgramCodeID | NO | YES | ||
| AmSuffix | Non-Identifying | Zero or One to Zero or More | FK_SyStudentAmSuffixID_AmSuffixAmSuffixID | AmSuffixID | NO | YES | ||
| SyPerson | Non-Identifying | Zero or One to Zero or More | FK_SyStudentSyPersonId_SyPersonSyPersonId | SyPersonId | NO | YES |
| Child Relationships: |
| syStudent Check Constraints |
| Check Constraint Name | CheckConstraint |
| Chk_SyStudent_LastInterestDate_OriginalStartDate | (([LastInterestDate] > [OriginalStartDate] or [LastInterestDate] is null and [OriginalStartDate] is null or [LastInterestDate] is null and [OriginalStartDate] is not null) and ((not([LastInterestDate] is not null and [OriginalStartDate] is null)))) |
| syStudent Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group | PRIMARY |
| syStudent Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.Student |
NO | |||
| Physical (Microsoft SQL Server) dbo.syStudent |
NO |
| syStudent Where Used - Submodel Usage |
| syStudent Data Movement Rules |
| Name | Type | Rule Text/Value |